﻿CREATE PROCEDURE [dbo].[Hogar_Agente_ObtenerDocentes]   
AS 
BEGIN

/*****************************************************************************************************************************************/
-- Author: Carlos Mendoza
-- Purpose:   obtener todos los agentes que son docentes con sus datos
-- Returns:    ConsultaDocentes
/*****************************************************************************************************************************************/ 
	
	SELECT  [AgenteId],
			[Nombre],
			[Apellido]
	FROM	[dbo].[Agente] ag WITH (NOLOCK)
	WHERE [Activo] = 1 AND [AreaId] = 2 --Docentes activos
	ORDER BY [Apellido], [Nombre]
	
END